sExcel VBA 747Ӭνdҹy d

ѪIboWAåBNo󪺹L{OƶqejΧޥAiHOVBAνd򩵦sAϱzbާ@Excelɯ[oCHѪݥФe]tѤҦ{XνdҡAtXeھާ@֧lѺءCѤe䴩Excel 2007/2003/2002/2000C @@ѯS @@WL700Excel VBAνdҪs
@@HdҾɦVѻڨϥExcelɳ̦ĥBΪVBAޥ
@@HsؤOBBšAztΦalάd
@@KnowledgezǨhVBA
@@HЦѤExcelVBAdҡAiŪHɰѷ @² Hikaru WATANABE @@Xͩ饻֮qA۱qjǮɥNyLĲLBASICyAN@PqLtCLᬰF{WݭnAѻPL]Ⱥ޲ztλP]tΪغcA]ӴNPPC}FC[JFjͩҶ}]EUCuExcel User ClubvAPɶ}lĲVBACO@ӻŷR֡BåBOTӤpĪˡC 


dҦpU:

owܤxsd
oҥΤxs
oHJҿܪxs
ou@ϥνd
oQ]tNxs椧ťզCAҳ_Ӫd
qNxsdӨowi۹ﲾʤxsd
oܧ󬰩ҫwjpxsd
oDCH~xsd
oNxsd򤧥kU誺xs
oxsd򤧥kU誺xs
owJxs檺d
oJ`ơ]H~^xs檺d
oJƭȤxs檺d
oJrꤧxs檺d
oѷӤFҩwqW٪xs椧d
o]tFNxs椧Xxs檺d
oJ󤺮e̫xs]H@CؼС^
oJάOȪ̫xs]H@CؼС^
owܭȪ̫xs]H@CؼС^
oJ󤺮e̫xs]H@欰ؼС^
oJάOȪ̫xs]H@欰ؼС^
oܭȪ̫xs]H@欰ؼС^
oJ󤺮e̫xs]HƼƦCؼС^
oJάOȪ̫xs]HƼƦCؼС^
oܭȪ̫xs]HƼƦCؼС^
oJ󤺮e̫xs]HƼ欰ؼС^
oJάOȪ̫xs]HƼ欰ؼС^
oܭȪ̫xs]HƼ欰ؼС^
oƼxsd򤧩MX
oƼxsd򤧩MX]jBz^
obƼxsd򤤳sbxs
oѷӤFNxsd
oѷӤFNxsd]L^
oѷӤFNxs檺xsd
o]tFNxs檺
o]tFNxs檺ӦC
oDܪxsd]ܪxssbɡ^
oܩxsd
oWN󪺥W]kU^xs
o]wFʰϰ쪺xsd
ocsxsd򪺦Uxsd
oH}rҫwxsd
oH}rҫwd
oH}rҫwCd
oH/Csҫwxsd
oH@ssҫwxsd
owFWΥkUxs檺xsd
o̫eu@
oҿܪu@
oHީҫwu@
o̥k䪺u@
o̥䪺u@
oHW٨ӫwu@
oHW٨ӫwu@]Ƽơ^
osW[u@
oSwxssbu@
o̫eï
ozLީҫwï
ozLW٨ӫwï
oss@XӪï
ogFoӵ{Xï
o̫Ҷ}Ҫï
oSwu@sbï
o̫e
os}Ҫ
oSwu@ï
ozLW٩ҫw
ozLީҫw
osW[
o̫ҷsW
oxs檺
oxs檺ܦr
oxs椧rꪺ@
Nxsd򪺭ȥNJVariantܼƥHϨ}C
oxs檺]OɴNoȡ^
oxs檺}YŸ
oxs檺ܤ覡
oxs檺Interior
oxsFont
oxs檺Style
oxs椧ؽuA
oxs檺榡
oxs檺JWh
oxs椧ȪW]ҾAΡ^
oxs檺
oxs檺Ws
oxs檺jp
oxs檺Wy
oxsѷӦ}
Pwxs椤O_J}C
PwO_]t
PwO_]t}C
POxsO_X
ou@W
C|u@W
ou@O@A
ou@ާ@\iA
ou@O_]wz
ou@ܪA
C|ïW
C|ï|
C|ï|W
oï¦W
C|ïݩ
PwïO_OHŪ覡}Ҫ
PwïOOxsAܧLӪ
oïO@A
PwOOWqï
o[󬡭ïOC
oΪA
o~تTwT
oUܪA
oA]jp^
oExcel]jp^A
oExcel
o|Ϲjr]Nhʪr^
oExcel|
odxs|
o禡wƧ|
ow]ثeؿ|
oExcelҰʥؿ|
ow]wLW
bxs椤Jƭ
xs椤J
bxs椤Jr
mxs檺
mxs檺ȡ]u@ơ^
bƼxs椤JۦP
bxsd򤺥Ѱ}CJƭ
bxs椤J]A1榡^
bxs椤J]R1C1榡^
bxs椤J}C
bxs椤Jsȡ]]t^
]wxs檺榡
]wxsȪWP`
]wxs檺rC
]wxs檺I
Ypxs檺eHܥX
bxsd~]wؽu
Rxsd򪺮ؽu
]wxs椧Ȫܦm
]wxs椧rꪺ@榡
bxsd򤤩wqW
xsdwqW١]Addk^
ѦCӳ]wxs檺JWh
wxs檺jp]I^
wxs檺jp]^
xs檺jpŦXҿJƤ
bxs椤]wWs
bxs椤]w
bxs椤]w榡
wxs
]w]txsbC/檺/
ܧҪC]Excel2002^
ܧW
sWu@ܧW١]ws^
T{sb]1^
T{sb]2^
]wO_iHiާ@
]wu@ܪA
ïܬwxs
]wAddinïBάONѰ
]wɮתݩʤe
ܧҥΤjp
ܧҥΤm
]wΪA
]wUܪA
]wܩWxs
]wܭv
]w/
ܧƹС]F|^
]wϥΪL
ܧExceljp
ܧExcelܦm
NExcelʨe~
Excel
ܧExcelDCr
RExcelD
ĵiT
]ù
NNrܨ쪬AC
ܪAC
ܤC
eʧ@
ƥL
L
۰/ʭp
]wJ᪺xs沾ʤV
A1榡AR1C1榡
ܧw]ɮצm
ܧbsïs@XӮɪu@
sWWq
Xxs
Ѱxs檺X
Mxs
ƻsxsd]^
ƻsxs檺ȡ]PasteSpecialk^
ƻsxs椤(Valueݩ)
ƻsFYH~xs椺e]ȡE^
ƻs]tFY㪺xs椺e]ȡE^
xsƭȧ@B
ƻsxs檺e
Ƚƻsxs檺ؽu
NNxsd@Ϲӽƻs]Ss^
NNxsd@Ϲӽƻs]s^
Jxs
Rxs
ܵe~xsAñNܦb
xsAܦbeW
ܦbW]tFSwrꪺҦ
ƻsu@
sWu@
Ru@
RϪ
ʤu@
O@u@
Ѱu@O@
HW٨ӱƧǤu@
ܪܸX
NbhŤUҩwquW١vR
}Ҭï
bssAU}Ҭï
HŪ覡}Ҭï
ɮץH}Ҭï
ɮסALkbExcelW}ҮɴN}
O@ï
s@sWï
xsï
tsï
]wO@KXAåtsï
]wקvKXAåtsï
wïWxs
wïW٨xsAwgsbɴNNg
xsïƥ
ï
Ҧï
xsҦï
RҦwq󬡭ïW
Nïl[ɮױHX
l[s
ʵ
sƦC
ε{
jMƭȥHΤr]Find xlFormulas^
jMƭȥHΤG]Find xlValues^
jMȻPG]Match^
bxsd򤺨oP@PxsӼơ]Loop^
bxsd򤺨oP@PxsӼơ]CountIf^
obxsd򤺬O_P@P
HӷjM(DCountA)
qƼƬï/ӷjM]Find^
oȡ]WorksheetFunction.VLookup^
oȡ]Application.VLookup^
oȡ]Find Offset^
oȡ]Collection^
oȡ]DGet^
۰ʿz
Ѱ۰ʿz
zﶵ
Ѱzﶵ
ƻszL
ƻszLơ]SpecialCells^
ozLƪ
zSX{bzﵲGC
Nz諸GܨOd
Nz諸GwBísƧǫܨOd
ƨӶiz
iANҩ褤sbX
iANusbY@誺X
H|ӥHWȨӱƧ
ϥΦۭqwqӱƧ
ƧǷsW۳ЪۭqwqC
ȮɶiƧǡBM٭즨쪬
wURLHNWebŪJ
NCSVɮ׶}Ҧï
w榡ӱNCSVɮ׶}Ҧï
NCSVɮŪJ]QueryTable ODBC^
NCSVɮŪJ]QueryTable TEXT^
NCSVɮŪJ]ADO^
NCSVɮŪJ]DAD ODBCDirect^
tŪJCSVɮס]FSO^
N257HWCSVɮפ}ŪJƼƭӪ]FSO RegExp^
NJsxsCSVɮ
NJsơ]}C^gXCSVɮ
tNƼgJCSVɮפ]FSO^
NܽdxsƼgXCSVɮ
NxlsɮŪJ]QueryTable ODBC^
ŪJxlsɮס]ADO^
ŪJxlsɮס]DAO DBCDirect^
NmdbɮתŪJW]QueryTable ODBC^
NmdbɮתŪJW]ADO^
NmdbɮתŪJW]DAO^
NmdbɮתSwOŪJW]ADO^
NmdbɮתSwOŪJW(DAO)
NmdbɮתdߵGŪJW(ADO)
NmdbɮתdߵGŪJW]DAO^
HSQLԭzӱqmdbɮפNŪJW(ADO)
HSQLԭzӱqmdbɮפNŪJW]DAO^
qu@ӼgJmdbɮת椤]ADO^
u@ӼgJmdbɮת椤]DAO^
q}CӼgJmdbɮת椤]ADO^
q}CӼgJmdbɮת椤]DAO^
s@mdbɮתs@dߡ]ADO^
s@mdbɮתs@dߡ]DAO^
HwWٻs@Xmdbɮס]ADO^
HwWٻs@Xmdbɮס]DAO^
omdbɮתW٦C]ADO^
omdbɮתW٦C]DAO^
omdbɮתwq]ADO^
omdbɮתwq]DAO^
omdbɮתdߩwq]ADO^
omdbɮתdߩwq]DAO^
omdbɮתdݩʡ]ADO^
omdbɮתdݩʡ]DAO^
ѪWwqӦbmdbs@]ADO^
ѪWwqӦbmdbs@]DAO^
HJsd߬¦Aӷss@X@Ӭdߡ]ADO^
HJsd߬¦Aӷss@X@Ӭdߡ]DAO^
RmdbɮתBBd
RmdbɮתBOBdߡ]DAO^
omdbɮתSchemaTƿ
NSQLServerŪJW]QueryTable ODBC^
NSQLServerŪJW]ADO^
NSQLServerŪJW]DAO ODBCDirect^
HSQLServerӰSQLԭz]ADO^
qWwqAӦbSQLServers@]ADO^
NOracleŪJW]QueryTable ODBC^
NOracleŪJW]ADO^
NOracleŪJW]DAO ODBCDirect^
NOracleŪJW]0040^
HOracleӰSQLԭz]ADO^
HOracleӰSQLԭz]0040^
ƫA`ഫơ]ADO^
`ഫơ]DAO^
d`ഫơ]DAO^
C|Shape
s@Shape󪺦PɽᤩW
bShapeWʺAn
ܥNShape
isդƫƻsBMbKWѰsդ
ʡBShape]ʵeơ^
NShapeTwbW
bShapeW]wr
NShapexsϹ
ϥγzShapeӫO@
q|󤤡ANNܨ̫e
s@Ϫ]ƼƭӹϪ^
s@Ϫ]XYGϡ^
ƼƭӹϪm
ܧϪ
NOϪܦbϪ
ܧϪƽd
oϪtCͶսu{
NϪxsϹ
NϪܦbv
oϪӸƽd
s@ϯäR]ơ^
s@ϯäR]~ơ^
ܧϯäRƽd
s@ϯäR
ѼϯäRoN
]wDC
]wAѰCLd
]wCLV
Hӳ]wd
]w
]w
ƻs]w
bNm]w
o
HN榡ӳ]wJCL
ܦLܪܤ
ܦCLw
ܦCLw]ܤ^
ܴw
o]ƫwӦ۰ʳ]wv]Zoom^
wCLL
ܤعܤ
bJ]wl
JJ
ܧGetOpenFilenamekw]ؿ
ܧGetOpenFilenamekﶵ
jGetOpenFilenamek~
ܧGetSaveAsFilenamekw]ؿ
jGetSaveAsFilenamek~
C|OC@
C|OCFaceID]OCW^
C|OCFaceID]W^
bOCsWn۳ЪϹ
OC
ROC
קxs檺k
bۭqWܥXk
bNmWXOC
bOCNmmJju
bOCWsWզX
éҦJsOC
NOCܦ^JsA
bu@Ƥϥΰ}C]G}C^
bu@Ƥϥΰ}C]@}C^
wdip
p⤽rHǦ^
Hrӫw
C|ҿJ
ܧ󤽦~ѷӪsؼ
ixs椧Ȫˬd
üƱƧǩҫw}C
Ƨǰ}C]BubbleƧǡ^
Ƨǰ}C]MergeƧǡ^
Ƨǰ}C]ֳtƧǡ^
Ƨǰ}C]ֳtƧǡ^
wƽdܸƪ
C|u@WExcel
oExcel
bMBզX]w
Excelo
ʷsWExcelBó]w
CI@NܧExcelrC
bhӪExcelϥΦ@q
C|u@WActiveX
oActiveX
bActiveXW]w
ActiveXo
HModelessܦۭq
wۭq檺ܦmܥX
NۭqܦbWܥXӪm
Nۭqs@XhӹӨϥ
q~NȶǤJۭq
ܨLïۭq
THuXvs
lƱ
oQܪ
oJۭq
LkϥΡ]ܦǦ^A
ܡ]Visible^
N]ܡ]TopBLeft^
bOsܰ檬A
brrꤤ]w榡
rJ
rJA
NrrΨӭp
rrbNrƫᴫ
bM]wơ]RowSource^
bM]wơ]AddItem^
Ѱ}CӱNƳ]wM]List^
Ѱ}CӱNƳ]wM]Column^
ѲMoơ]Value^
ѲMoơ]ListBColumn^
ѲMӥH}Co
ѲMӧOR
ѵ{XӫwMܶ
MܪA
MܪA
bMi즲ާ@
qiiƼƿܪMoܶ
ƧǲM
bզX]wơ]RowSource^
bզX]wơ]AddItem^
bզXH}Cӳ]wơ]List^
bզXH}Cӳ]wơ]Column^
ѲզXӨoơ]Value^
ѲզXӨoơ]ListBColumn^
ѲզXӥH}C覡o
ѲզXӭӧOR
ѵ{XӫwզXܶ
զXܪA
զXܪA
զXuqM椤ӿ
JIN۰ʶiDropDown
ƧǲզX
osդONﶵs
oQON֨
ʦCPʶbs
LիsPrs
LիsܤƬSyClick
HsONBOFFܧD]Caption^
ʺAabvܹϹɮ
NvϹxsɮ
NұO²CӨϥ
C|Frame
bTabStrip]w
bSyClickih
bTabStrip]w
bRichTextr즲ϹHo|]ȭ2002^
ѰŶKïorr
NrrxsŶKï
NrOƥHiJ
NﶵsClickƥO
s@ШƥAHoJIʸT
T{ƥ
bҥΤɰ{X
bGUBze{X]xs檺GU^
bkBze{X]xs檺kI^
bipɰ{X
bxsȳQܧɰ{X
ҥΪAɰ{X
bWsɰ{X
xs椧ܽdQܧɰ{X
bܧ榡{X
ѼзǼҲըӳ]wƥ
bϪҥΪAɰ{X
bGUBze{X]nGU^
bkIBze{X]nkI^
bϪҥΪAɭ԰{X
NxsdϪWɰ{X]Chart_DragOver^
NxsdϪWɰ{X]Chart_DragPlot^
ϪWIƹɰ{X
ϪWʤFƹЮɰ{X
ϪW}ƹsɰ{X
bܧFϪjpɰ{X
bܤFϪnɰ{X
bܧFϪƦCnȮɰ{X
bGUFIɭܫen
bܤFϪnɧܨӷƤxsC
T{ïƥ
bïҥΤɰ{X
bïQOWqɰ{X
bïѰFWqOɰ{X
bïQɡAe{X
bi次ïCL/wCLe{X
bïQxse{X
bïOҥΤɰ{X
bïsWɰ{X
bïQ}Үɰ{X
bïҥΪAɰ{X
bGUBze{X]ï^
bkIBze{X]ï^
bïWipɰ{X
bïxsȳQܧɰ{X
bïAҥΪAɰ{X
bïWsQɰ{X
bïxsܽdQܧɰ{X
bïҥΪAɰ{X
bïAҥΪAɰ{X
bïjpQܧɰ{X
qзǼҲդӳ]wïƥ]۰ʥ^
qзǼҲդӳ]wïƥ]Ontݩʡ^
T{ε{ƥ
bsWïQs@XӮɰ{X
bҥΤAɰ{X
bGUIe{X]xs檺GU^
bƹkIe{X]xs檺kI^
bWipɰ{X
bxs檺ȳQܧɰ{X
bOҥΤAɰ{X
bWWsQɰ{X
xs檺ܽdQܧɰ{X
ҥΪAɰ{X
AҥΪAɰ{X
jpQܧɰ{X
ïҥΤAɰ{X
ïQsOWqɰ{X
ïWqOQѰɰ{X
ïQɡAe{X
bïCL/wCLe{X
bïQxsɡAxse{X
ïҥΤAɰ{X
QsWɰ{X
ïQ}Үɰ{X
TExceljpܧ
T{ۭq汱ƥ
oJIe{X
bJIʫe{X
bhJIBƦܧɨӰ{X
bnܧ󱱨ȡ]Valueȡ^ɭ԰{X
bƦ]ϥΪ̪ާ@ܧɰ{X
Uɰ{X
bUFiJrɰ{X
}Uɰ{X
Uƹsɰ{X
bƹвʮɰ{X
}QUɰ{X
bGUɭ԰{X
bƹI諸ɭ԰{X
bUԦ]Drop Down^Q]ܩîɰ{X
bʦCȲܤƫ{X
bʤFʦCʤɰ{X
bLիsȦܤƮɰ{X
bIFLիsWsɰ{X
bIFLիsUsɰ{X
T{Wƥ
oFJIɰ{X
WhFJIɰ{X
次ï{
Lï{
Lï۰ʥ
bwɶ{
w޼ƨӰ{ǡ]@^
w޼ƨӰ{ǡ]RunBOnTime^
ϥΦrܼƧ@n檺{ǦW١]RunBOnTime^
ٲ޼ƪgk
VariantA޼
b{Ǫ~
bIs{X
ܤnܵ{ǦW
iwƪj
bj餤~]Exit For^
}CҦnij
ﶰXҦij
wjɶ
bj餤~]Exit Do^
NSWhʪnij
ihj
ϥέs^Ӷij
ϥΤsƨӶij
P_r
P_O_ƭ
P_O_Ĥ
HO_}CӶiP_
P_O_
P_bܼƤO_xs۪
HO_~oͨӶi[Bz
P_Ob٬OΦr
P_jpg
_WΤW]ҾAΡ^
HƼƱӧ@[Bz
HSelect CaseӨϥLikeBl
C|ݩ
]wҲժW
]wïҲժW
۰ʤƼҲժפJBץX
{XB]p
bVBEOCn
MYɹB
X]tҫwrꪺC
gXQŧiܼ
s@{ǦW٪M
۰ʻs@ۭq
C|Q]wޥΰѷӳ]w禡w
ʷsWޥΰѷӳ]w
ʸѰޥΰѷӳ]w
X
CXҫwƧɮס]FileSearch^
CXҫwƧɮס]}FileSearch^
CXҫwƧɮס]Dirơ^
T{ҫwƧAɮתsb
oҫwɮ׬O_Q}
ƻsɮ
Rɮ
s@Ƨ
RƧ
ܧɮעAƧW
ɮעAƧ
oثeϺо
ܧثeϺо
oثeƧ
ܧثeƧ
CXϺо
CXҫwϺоT
T{Ϻоsb
ƻsƧ
RƧ
ʸƧ
s@Ƨ
T{Ƨsb
CXƧlƧW
otθƧ|
oƧݩ
oƧT
ƻsɮ
Rɮ
ɮ
T{ɮתsb
ohFɦWɮצW١]¦W^
Ѹ|rꪺ̤UӨoɦW
Ѹ|rӨoɮצW
oƧ|
o|rꪺϺоW
C|ƧɮצW
oɮתݩ
oɮתT
ͶüƦr
HDPB覡Ұʥ~{
NHShellƩұҰʪ{ܨ̫e
HShellƨӱҰbatɮרðDirO
HShellƨӱҰʶlnõoXl
ExcelҰAccessæCLX
ExcelҰWordåHƨӶiX֦CL
ExcelҰPowerPointñNWϪKvW
ExcelҰOutlookAùW}oel
HCreateObjectӼȮɻs@@~Ϊ
sWrɮ
HCŪJrɮ
HrŪJrɮ
NӤrɮŪJ
ѫwCŪJrɮ
srɮ
bDictionary󤤷sW
DictionaryR
oȬ}C
Qΰ}Co
wHo
wHܧ󶵥
wýT{sbAMNܧ
ҰInternetExplorerAHܥXҫwURL
Ȯɻs@XtFORMҪhtmlɮסBåiHJjMr
Q½Ķ½Ķ^
Q½Ķ½Ķ^
ѩҫwWebӨoҦWs
ѩҫwWebӨXϹHKW
wƧ|H}s
oSƧ|
Nuڪ̷RvƧM
ow]wLW
ާ@x
ާ@w}Ҫ
}ҡuƧܡvܤ
ܥXuwɮצWٰ...vܤ
ɮ׹ϹƹkI
}CD-ROMiX
oɮ׸T
ܥX|۰ʮT
NWYӸƧ]ثeƧ
Ұʥ~{Aõݨ䵲]Execk^
Ұʥ~{Aõݨ䵲]Runk^
Ұʵ{AæbwɶNj
s@ɮת|
s@XWeb|
oT
oϺоT
oLW
]ww]L
HWΦӽT{Nrꪺsb
XbWΦU˦@Pr
NbWΦUҦ@Pr
APIƻP`ƪŧi
OW٨ӨoWindow Handle
ѼD]Caption^ӨoWindow Handle
ѼDӨoO
ѵOӨoD
ۭq檺uXvsR
bۭqW[̤jơB̤pƫsAHiHܤjp
ۭq椤uѡvsĩάO
oƹy
HAPIưeXTBH̫e
H@{Ȱ
Ұʱa޼ƪExcelAð楨